﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/02LABORATORISTA/MPLabo.Master" CodeBehind="labo-inscripcion.aspx.vb" Inherits="ASI_2_UFG.labo_inscripcion" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
    
 <style type="text/css">
   /*AutoComplete flyout */
.completionList {
border:solid 1px #444444;
margin:0px;
padding:2px;
height: 100px;
overflow:auto;
background-color: #FFFFFF;
text-align:left;

}

.listItem {
color: #1C1C1C;
}

.itemHighlighted {
background-color: #F88017;
font-weight:bold;
}
   </style>
   
   <script type="text/vbscript">
    anio = Response.wirte Year(now)
   </script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="tableform">
    <fieldset><legend>INSCRIPCION DE ALUMNOS</legend></fieldset>
    <table>
        <tr>
            <td>
                <asp:Label ID="Label1" runat="server" Text="ESTUDIANTE"></asp:Label>
            </td>
            <td>
                <asp:ToolkitScriptManager ID="ScriptManager" runat="server">
                </asp:ToolkitScriptManager>
                <asp:TextBox ID="txtCARNET" runat="server"></asp:TextBox>
                <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" 
                    CompletionInterval="100" MinimumPrefixLength="1" TargetControlID="txtCARNET" ServiceMethod="SearchEstudiante"
                     CompletionListCssClass="completionList" CompletionListItemCssClass="listItem" CompletionListHighlightedItemCssClass="itemHighlighted">
                </asp:AutoCompleteExtender>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="Label2" runat="server" Text="GRUPO"></asp:Label>
            </td>
            <td>
                <asp:SqlDataSource ID="sqlGrupo" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ASI2UFG %>" SelectCommand="select g.id_grupo,
{fn concat(m.codigo, {fn concat(' ', {fn concat(cast (h.hora_inicio as varchar), {fn concat (' - ', cast (h.hora_fin as varchar) )})} )})} AS GRUPO
FROM GRUPO AS g, MATERIA AS m, HORARIO AS h
WHERE g.id_materia=m.id_materia AND g.id_horario=h.id_horario"></asp:SqlDataSource>
                <asp:DropDownList ID="Grupo" runat="server" DataSourceID="sqlGrupo" 
                    DataTextField="GRUPO" DataValueField="id_grupo">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="Label3" runat="server" Text="CICLO"></asp:Label>
            </td>
            <td>
                <asp:DropDownList ID="frpCiclo" runat="server">
                    <asp:ListItem Value="01"> CICLO 01</asp:ListItem>
                    <asp:ListItem Value="02"> CICLO 02</asp:ListItem>
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="Label4" runat="server" Text="AÑIO"></asp:Label>
            </td>
            <td>
                <asp:TextBox ID="ANIO" runat="server"  ReadOnly="true"></asp:TextBox>
                <br />
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="Label5" runat="server" Text="PERSONAL"></asp:Label>
            </td>
            <td>
                <asp:TextBox ID="txtPersonal" runat="server" Text="" ReadOnly="true"></asp:TextBox>
            </td>
        </tr>
        <tr>
            <td>
                <asp:Label ID="Label6" runat="server" Text="GRUPO TEORICO"></asp:Label>
            </td>
            <td>
                <asp:SqlDataSource ID="sqlGrupo_Teorico" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ASI2UFG %>" SelectCommand="SELECT g.id_grupo_teorico,
{fn concat (' ', {fn concat (m.codigo,{fn concat (' ', {fn concat (p.apellidos, {fn concat (',', p.nombres)})})})})} AS GRUPO
  
FROM GRUPO_TEORICO AS g, MATERIA AS m, PERSONAL AS p
WHERE G.id_materia=M.id_materia and G.id_personal=p.id_personal"></asp:SqlDataSource>
                <asp:DropDownList ID="Grupo_teorico" runat="server" 
                    DataSourceID="sqlGrupo_Teorico" DataTextField="GRUPO" 
                    DataValueField="id_grupo_teorico">
                </asp:DropDownList>
            </td>
        </tr>

    </table>
</div>
</asp:Content>
